﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Manage/ManageMasterPage.master" AutoEventWireup="true" CodeFile="AssignList.aspx.cs" Inherits="Manage_AssignOrd"  Theme="主题1"%>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div style="width: 100%; text-align:center;background-color:#f3f9eb;float:left;padding-bottom:100px" >        
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" CssClass="mGrid" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" >
            <Columns>
                <asp:CommandField SelectText="分派" ShowSelectButton="True" />
                <asp:BoundField DataField="Ono" HeaderText="订单编号" SortExpression="Ono" />
                <asp:BoundField DataField="Aaccount" HeaderText="订餐账号" SortExpression="Aaccount" />
                <asp:BoundField DataField="Oname" HeaderText="收餐姓名" SortExpression="Oname" />
                <asp:BoundField DataField="Ophone" HeaderText="联系方式" SortExpression="Ophone" />
                <asp:BoundField DataField="Opayway" HeaderText="支付方式" SortExpression="Opayway" />
                <asp:CheckBoxField DataField="Opaystate" HeaderText="支付情况" SortExpression="Opaystate" />
                <asp:BoundField DataField="SOremarks" HeaderText="订单备注" SortExpression="SOremarks" />
                <asp:BoundField DataField="SOtime" HeaderText="下单时间" SortExpression="SOtime" />
                <asp:BoundField DataField="Ostate" HeaderText="订单状态" SortExpression="Ostate" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=SUBAI-WORKSTATI;Initial Catalog=Restaurant;Persist Security Info=True;User ID=Manager;Password=321" ProviderName="System.Data.SqlClient" SelectCommand="SELECT DISTINCT [Ono], [Aaccount], [Oname], [Ophone], [Opayway], [Opaystate], [SOremarks], [SOtime], [Ostate] FROM [Manager_ViewOrder] WHERE ([Ostate] = @Ostate or [Ostate] = @Ostate2)">
            <SelectParameters>
                <asp:Parameter DefaultValue="已接单" Name="Ostate" Type="String" />
                <asp:Parameter DefaultValue="申请退单" Name="Ostate2" />
            </SelectParameters>
        </asp:SqlDataSource>
   </div>
</asp:Content>

